Go to the documentation of this file.
00001 
00028 using System;
00029 using System.Collections;
00030 using System.Configuration;
00031 using System.Data;
00032 using System.Linq;
00033 using System.Web;
00034 using System.Web.Security;
00035 using System.Web.UI;
00036 using System.Web.UI.HtmlControls;
00037 using System.Web.UI.WebControls;
00038 using System.Web.UI.WebControls.WebParts;
00039 using System.Xml.Linq;
00040 
00041 using RAIS.Common.TableManagement;
00042 using RAIS.Common.UserManagement;
00043 using RAIS.UI.Common;
00044 
00045 using Queries = System.Collections.Generic.Dictionary<string, RAIS.Common.TableManagement.Query>;
00046 using QueryParameters = System.Collections.Generic.Dictionary<string, RAIS.Common.TableManagement.QueryParameter>;
00047 using QueryParameterTypes = System.Collections.Generic.Dictionary<string, RAIS.Common.TableManagement.QueryParameter.QueryParameterTypeData>;
00048 using Tables = System.Collections.Generic.Dictionary<string, RAIS.Common.TableManagement.Table>;
00049 
00050 namespace RAIS.UI.SpecificMasks
00051 {
00055         public partial class CustomQueryParameters : System.Web.UI.Page
00056         {
00057                 //*********************************************************************
00058                 #region Enums
00059 
00062         enum CustomQuery_PageMode
00063                 {
00064                         view,
00065                         add,
00066                         edit
00067                 };
00068                 #endregion Enums
00069                 //*********************************************************************
00070                 #region Properties
00071         protected void Page_PreLoad(object sender, EventArgs e)
00072         {
00073             RAIS.UI.Common.PageManagement.TrimTextBoxValues(this);
00074         }
00078                 protected UserData CurrentUser
00079                 {
00080                         get { return (UserData)this.Session[UI.Common.Constants.CURRENT_USER_TAG]; }
00081                 }
00085                 CustomQuery_PageMode CurrentCustomQuery_PageMode
00086                 {
00087                         get
00088                         {
00089                                 if (this.Session[UI.Common.Constants.CUSTOM_QUERY_PARAMETERS_EDIT_MODE_TAG] != null)
00090                                 {
00091                                         return (CustomQuery_PageMode)this.Session[UI.Common.Constants.CUSTOM_QUERY_PARAMETERS_EDIT_MODE_TAG];
00092                                 }
00093                                 else
00094                                         return CustomQuery_PageMode.view;
00095                         }
00096                         set
00097                         {
00098                                 this.Session[UI.Common.Constants.CUSTOM_QUERY_PARAMETERS_EDIT_MODE_TAG] = value;
00099                                 this.SetControlsProperties();
00100                         }
00101                 }
00105                 bool EditMode
00106                 {
00107                         get 
00108                         {
00109                                 return this.CurrentCustomQuery_PageMode == CustomQuery_PageMode.edit
00110                                         || this.CurrentCustomQuery_PageMode == CustomQuery_PageMode.add;
00111                         }
00112                 }
00116                 private string SavedQuerySelection
00117                 {
00118                         get
00119                         {
00120                                 if (this.Session[RAIS.UI.Common.Constants.QUERY_SAVED_SELECTION_TAG] != null)
00121                                         return this.Session[RAIS.UI.Common.Constants.QUERY_SAVED_SELECTION_TAG].ToString();
00122                                 else
00123                                         return string.Empty;
00124                         }
00125                 }
00129                 private RAIS.Common.TableManagement.Query SelectedQuery
00130                 {
00131                         get
00132                         {
00133                                 Queries queries = UI.Common.TableManagement.GetQueries(this, false);
00134                                 if (queries != null && queries.ContainsKey(this.SavedQuerySelection))
00135                                         return queries[this.SavedQuerySelection];
00136                                 else
00137                                         return null;
00138                         }
00139                 }
00143                 private QueryParameter SelectedQueryParameter
00144                 {
00145                         get
00146                         {
00147                                 QueryParameters queryParameters = UI.Common.TableManagement.GetQueryParametersByQuery(this, this.SelectedQuery, false);
00148                                 if (queryParameters != null && queryParameters.ContainsKey(this.LBqueryParameters.SelectedValue))
00149                                         return queryParameters[this.LBqueryParameters.SelectedValue];
00150                                 else
00151                                         return null;
00152                         }
00153                 }
00157                 private QueryParameter.QueryParameterTypeData SelectedQueryParameterTypeData
00158                 {
00159                         get
00160                         {
00161                                 QueryParameterTypes queryParameterTypes = ApplicationLogicLayer.TableManagement.GetQueryParameterTypesByQuery(this.SelectedQuery);
00162                                 if (queryParameterTypes != null && queryParameterTypes.ContainsKey(this.DDLparameterType.SelectedValue))
00163                                         return queryParameterTypes[this.DDLparameterType.SelectedValue];
00164                                 else
00165                                         return null;
00166                         }
00167                 }
00171                 private RAIS.Common.TableManagement.Table SelectedTable
00172                 {
00173                         get
00174                         {
00175                                 Tables tables = RAIS.ApplicationLogicLayer.TableManagement.AllTables;
00176                                 if (tables != null && tables.ContainsKey(this.DDLqueryParameterTable.SelectedValue))
00177                                         return tables[this.DDLqueryParameterTable.SelectedValue];
00178                                 else
00179                                         return null;
00180                         }
00181                 }
00185                 private RAIS.Common.TableManagement.Query SelectedRelatedQuery
00186                 {
00187                         get
00188                         {
00189                                 Queries queries = UI.Common.TableManagement.GetQueries(this, false);
00190                                 if (queries != null && queries.ContainsKey(this.DDLqueryParameterRelatedQuery.SelectedValue))
00191                                         return queries[this.DDLqueryParameterRelatedQuery.SelectedValue];
00192                                 else
00193                                         return null;
00194                         }
00195                 }
00196                 #endregion
00197                 //*********************************************************************
00198                 #region Event handlers
00199 
00205                 protected void Page_Load(object sender, EventArgs e)
00206                 {
00207                         this.Response.Cache.SetNoStore();
00208                         if (this.CurrentUser == null)
00209                                 UI.Common.AccessManagement.SignOut(this);
00210                         this.LBLresult.Text = string.Empty;
00211 
00212                         if (!this.IsPostBack)
00213                         {
00214                 this.BTNdelete.Attributes.Add("onclick", string.Format("javascript: return confirm('{0}');", RAIS.Common.Messages.DELETE_QUESTION_CUSTOM_QUERY_PARAMETER.Replace("'", "\\'")));
00215                 this.LBLusernameNoTranslation.Text = this.CurrentUser.Name;
00216                                 this.LBLqueryName.Text = this.SavedQuerySelection;
00217                                 string translatedMessage = RAIS.ApplicationLogicLayer.Localisation.Translate(RAIS.Common.Messages.FIELD_IS_MANDATORY,
00218                                                                                                                                                                                         RAIS.Common.Messages.TRANSLATION_CONTEXT,
00219                                                                                                                                                                                         RAIS.Common.Constants.DEFAULT_LANGUAGE,
00220                                                                                                                                                                                         this.CurrentUser.Language);
00221                                 this.RFVqueryParameterVisibleName.ErrorMessage = translatedMessage;
00222                 this.LBLadmin.ForeColor = RAIS.UI.Common.Constants.COLOR_OF_MENU_BAR_TEXT_HIGHLIGHT;
00223                                 this.InitializeQueryParameters(string.Empty);
00224 
00225                                 UI.Common.PageManagement.InitializePage(this, this.TreeView1);
00226                                 //UI.Common.PageManagement.InitializePageTreeForCategory(this, this.TreeView1, RAIS.Common.Constants.CATEGORY_NAME_ADMINISTRATION);
00227 //                              this.LBTNmessagebox.Visible = !(this.CurrentUser.FunctionalRole.Type == FunctionRole.FunctionRoleType.Guest);
00228                         }
00229             PageManagement.InitHelpMainMenu(LBTNdefault);
00230                 }
00237                 protected void Page_Init(object sender, EventArgs e)
00238         {
00239             PageManagement.SetScrolableListBox(LBqueryParameters, this, true);
00240         }
00247                 protected void LNKraisCustomization_Click(object sender, EventArgs e)
00248                 {
00249                         this.Response.Redirect("~/CustomQueryRaisCustomization.aspx");
00250                 }
00257                 protected void LBqueryParameters_SelectedIndexChanged(object sender, EventArgs e)
00258                 {
00259                         this.OnSetQueryParameterValue();
00260                         this.SetControlsProperties();
00261                 }
00268                 protected void DDLparameterType_SelectedIndexChanged(object sender, EventArgs e)
00269                 {
00270                         this.OnSetQueryParameterTypeValue();
00271                         this.SetControlsProperties();
00272                 }
00279                 protected void BTNadd_Click(object sender, EventArgs e)
00280                 {
00281                         this.CurrentCustomQuery_PageMode = CustomQuery_PageMode.add;
00282                         this.LBqueryParameters.Items.Add(new ListItem(string.Empty));
00283                         this.LBqueryParameters.SelectedIndex = LBqueryParameters.Items.Count - 1;
00284                         this.OnSetQueryParameterValue();
00285                         this.SetControlsProperties();
00286                 }
00293                 protected void BTNedit_Click(object sender, EventArgs e)
00294                 {
00295                         bool success = false;
00296                         string returnMessage = string.Empty;
00297                         success = UI.Common.TableManagement.CheckQueryAssignedObjects(this.SelectedQuery, ref returnMessage);
00298                         if (success)
00299                         {
00300                                 this.CurrentCustomQuery_PageMode = CustomQuery_PageMode.edit;
00301                         }
00302                         else
00303                         {
00304                                 RAIS.UI.Common.MessageDisplay.DisplayReturnMessage(this.LBLresult,
00305                                                                                                                                 returnMessage,
00306                                                                                                                                 success);
00307                         }
00308                 }
00315                 protected void BTNdelete_Click(object sender, EventArgs e)
00316                 {
00317                         bool success = false;
00318                         string returnMessage = string.Empty;
00319 
00320                         QueryParameter queryParameter = this.SelectedQueryParameter;
00321                         success = RAIS.ApplicationLogicLayer.TableManagement.RemoveQueryParameter(queryParameter, ref returnMessage);
00322                         if (success)
00323                         {
00324                                 this.CurrentCustomQuery_PageMode = CustomQuery_PageMode.view;
00325                                 string newSelection = (this.LBqueryParameters.SelectedIndex == 0)
00326                                         ? string.Empty
00327                                         : this.LBqueryParameters.Items[this.LBqueryParameters.SelectedIndex - 1].Value;
00328                                 this.InitializeQueryParameters(newSelection);
00329                         }
00330 
00331                         RAIS.UI.Common.MessageDisplay.DisplayReturnMessage(this.LBLresult,
00332                                                                                                                                 returnMessage,
00333                                                                                                                                 success);
00334                 }
00341                 protected void BTNdiscard_Click(object sender, EventArgs e)
00342                 {
00343                         if (this.CurrentCustomQuery_PageMode == CustomQuery_PageMode.add)
00344                         {
00345                                 this.LBqueryParameters.Items.Remove(this.LBqueryParameters.SelectedItem);
00346                                 if (this.LBqueryParameters.Items.Count != 0)
00347                                         this.LBqueryParameters.SelectedIndex = LBqueryParameters.Items.Count - 1;
00348                         }
00349                         this.CurrentCustomQuery_PageMode = CustomQuery_PageMode.view;
00350                         this.OnSetQueryParameterValue();
00351                         this.SetControlsProperties();
00352                 }
00359                 protected void BTNapply_Click(object sender, EventArgs e)
00360                 {
00361                         // Set success to true to call SaveQueryParameter if it is not of LookupFromQuery type
00362                         bool success = true;
00363                         string returnMessage = string.Empty;
00364 
00365                         // Get query properties from controls values
00366                         QueryParameter queryParameter = GetQueryParameterFromControls();
00367 
00368                         if (queryParameter.Type == QueryParameter.QueryParameterType.LookupFromQuery)
00369                         { 
00370                                 // Validate query parameters
00371                                 success = RAIS.ApplicationLogicLayer.TableManagement.ValidateQueryParameters(queryParameter.RelatedQuery , ref returnMessage);
00372 
00373                 if (queryParameter.RelatedQuery == null)
00374                 {
00375                     success = false;
00376                     returnMessage = "Choose custom query";
00377                 }
00378 
00379                                 // Create query
00380                                 if (success)
00381                                         success = RAIS.ApplicationLogicLayer.TableManagement.CreateQuery(queryParameter.RelatedQuery, ref returnMessage);
00382                         }
00383                         
00384                         // Save query parameter
00385                         if (success)
00386                                 success = RAIS.ApplicationLogicLayer.TableManagement.SaveQueryParameter(queryParameter, ref returnMessage);
00387 
00388                         if (success)
00389                         {
00390                                 // Set form into view mode
00391                                 this.CurrentCustomQuery_PageMode = CustomQuery_PageMode.view;
00392                                 this.InitializeQueryParameters(queryParameter.Name);
00393                         }
00394 
00395                         RAIS.UI.Common.MessageDisplay.DisplayReturnMessage(this.LBLresult,
00396                                                                                                                                 returnMessage,
00397                                                                                                                                 success);
00398                 }
00405                 protected void BTNup_Click(object sender, EventArgs e)
00406                 {
00407                         this.ChangeOrder(true);
00408                 }
00415                 protected void BTNdown_Click(object sender, EventArgs e)
00416                 {
00417                         this.ChangeOrder(false);
00418                 }
00425                 protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
00426                 {
00427                         UI.Common.UserManagement.ProcessTreeViewOnRedirect(this.TreeView1);
00428                 }
00435                 protected void LBTNlogout_Click(object sender, EventArgs e)
00436                 {
00437                         UI.Common.AccessManagement.SignOut(this);
00438                 }
00439                 #endregion
00440                 //*********************************************************************
00441                 #region Private helper methods
00442 
00443                 private void InitializeQueryParameters(string selection)
00444                 {
00445                         UI.Common.TableManagement.InitializeCustomQueryParametersListBoxByQuery(this.LBqueryParameters, this.SelectedQuery, selection);
00446                         this.OnSetQueryParameterValue();
00447                         this.SetControlsProperties();
00448                 }
00452                 private void OnSetQueryParameterValue()
00453                 {
00454                         if (this.SelectedQueryParameter == null)
00455                         {
00456                                 this.TXTqueryParameterName.Text = string.Empty;
00457                                 this.TXTqueryParameterVisibleName.Text = string.Empty;
00458                         }
00459                         else
00460                         {
00461                                 this.TXTqueryParameterName.Text = this.SelectedQueryParameter.Name;
00462                                 this.TXTqueryParameterVisibleName.Text = this.SelectedQueryParameter.VisibleName;
00463                         }
00464 
00465                         string selection = (this.SelectedQueryParameter == null) ? string.Empty : this.SelectedQueryParameter.TypeData.VisibleName;
00466                         UI.Common.TableManagement.InitializeQueryParameterTypeList(this.DDLparameterType
00467                                 , this.SelectedQuery
00468                                 , selection);
00469                         this.OnSetQueryParameterTypeValue();
00470                         this.SetControlsProperties();
00471                 }
00472 
00473                 private void OnSetQueryParameterTypeValue()
00474                 {
00475                         if (this.SelectedQueryParameterTypeData != null)
00476                         {
00477                                 if (this.SelectedQueryParameterTypeData.Type == QueryParameter.QueryParameterType.LookupFromTable)
00478                                 {
00479                                         string selection = (this.SelectedQueryParameter.Table == null) ? string.Empty : this.SelectedQueryParameter.Table.Name;
00480                                         UI.Common.TableManagement.InitializeTableListWithAllTables(this.DDLqueryParameterTable, selection);
00481                                 }
00482                                 if (this.SelectedQueryParameterTypeData.Type == QueryParameter.QueryParameterType.LookupFromQuery)
00483                                 {
00484                                         RAIS.Common.TableManagement.Query.QueryType queryType = RAIS.Common.TableManagement.Query.QueryType.PreselectionFilter;
00485                                         string selection = (this.SelectedQueryParameter.RelatedQuery == null) ? string.Empty : this.SelectedQueryParameter.RelatedQuery.Name;
00486                                         UI.Common.TableManagement.InitializeCustomQueryListByQueryType(this.DDLqueryParameterRelatedQuery, queryType, selection);
00487 
00488                                         selection = (this.SelectedQueryParameter.Table == null) ? string.Empty : this.SelectedQueryParameter.Table.Name;
00489                                         UI.Common.TableManagement.InitializeTableListWithAllTables(this.DDLqueryParameterTable, selection);
00490                                 }
00491 
00492                                 if (this.EditMode)
00493                                 {
00494                                         switch (this.SelectedQueryParameterTypeData.Type)
00495                                         {
00496                                                 case QueryParameter.QueryParameterType.UserID:
00497                                                         this.TXTqueryParameterVisibleName.Text = RAIS.Common.Constants.USER_PARAMETER_NAME;
00498                                                         break;
00499                                                 case QueryParameter.QueryParameterType.DatesRangeStartDate:
00500                                                         this.TXTqueryParameterVisibleName.Text = RAIS.Common.Constants.DATE_FROM_LABEL_TEXT;
00501                                                         break;
00502                                                 case QueryParameter.QueryParameterType.DatesRangeEndDate:
00503                                                         this.TXTqueryParameterVisibleName.Text = RAIS.Common.Constants.DATE_UNTIL_LABEL_TEXT;
00504                                                         break;
00505                                                 case QueryParameter.QueryParameterType.PrimaryKey:
00506                                                         this.TXTqueryParameterVisibleName.Text = RAIS.Common.Constants.PK_PARAMETER_NAME;
00507                                                         break;
00508                                                 case QueryParameter.QueryParameterType.PreselectedFacility:
00509                                                         this.TXTqueryParameterVisibleName.Text = RAIS.Common.Constants.FACILITY_PARAMETER_NAME;
00510                                                         break;
00511                                                 case QueryParameter.QueryParameterType.PreselectedDepartment:
00512                                                         this.TXTqueryParameterVisibleName.Text = RAIS.Common.Constants.DEPARTMENT_PARAMETER_NAME;
00513                                                         break;
00514                                                 default:
00515                                                         this.TXTqueryParameterVisibleName.Text = this.TXTqueryParameterName.Text;
00516                                                         break;
00517                                         }
00518                                 }
00519                         }
00520                 }
00524                 private void SetControlsProperties()
00525                 {
00526                         this.LNKcustomquery.Enabled = !this.EditMode;
00527                         this.LBqueryParameters.Enabled = !this.EditMode;
00528 
00529                         this.PNLqueryParameterControls.Enabled = this.EditMode;
00530                         foreach (Control control in this.PNLqueryParameterControls.Controls)
00531                                 if (control is BaseValidator)
00532                                         ((BaseValidator)control).Enabled = this.EditMode;
00533                         //this.RFVqueryParameterName.Enabled = this.EditMode;
00534 
00535                         this.LBLqueryParameterName.Enabled = false;
00536                         this.TXTqueryParameterName.Enabled = false;
00537 
00538                         this.LBLqueryParameterVisibleName.Text = GetVisibleNameLabelTranslatedText();
00539                         this.TXTqueryParameterVisibleName.Visible = GetVisibleNameControlVisible();
00540                         this.LBLqueryParameterVisibleName.Visible = this.TXTqueryParameterVisibleName.Visible;
00541                         this.TXTqueryParameterVisibleName.Enabled = 
00542                                 this.LBLqueryParameterVisibleName.Visible && this.EditMode;
00543                         //this.LBLqueryParameterVisibleName.Enabled = this.TXTqueryParameterVisibleName.Visible;
00544 
00545                         this.LBLqueryParameterTable.Text = GetTableLabelTranslatedText();
00546                         this.DDLqueryParameterTable.Visible = GetTableControlVisibility();
00547                         this.LBLqueryParameterTable.Visible = this.DDLqueryParameterTable.Visible;
00548                         this.DDLqueryParameterRelatedQuery.Visible = GetRelatedQueryControlVisibility();
00549                         this.LBLqueryParameterRelatedQuery.Visible = this.DDLqueryParameterRelatedQuery.Visible;
00550 
00551                         this.BTNadd.Enabled = !this.EditMode;
00552                         this.BTNedit.Enabled = !this.EditMode && this.SelectedQueryParameter != null;
00553                         this.BTNdelete.Enabled = !this.EditMode && this.SelectedQueryParameter != null;
00554                         this.BTNapply.Enabled = this.EditMode;
00555                         this.BTNdiscard.Enabled = this.EditMode;
00556                         this.EnableUpDownButtons();
00557 
00558                         if (this.EditMode)
00559                                 this.SetFocus(this.TXTqueryParameterVisibleName);
00560                         else
00561                                 this.SetFocus(this.LBqueryParameters);
00562 
00563                         UI.Common.UserManagement.EnableCommonControls(this, this.CurrentCustomQuery_PageMode == CustomQuery_PageMode.view);
00564                 }
00568                 private QueryParameter GetQueryParameterFromControls()
00569                 {
00570                         QueryParameter queryParameter = null;
00571 
00572                         if (this.SelectedQueryParameter == null)
00573                         {
00574                                 queryParameter = new QueryParameter();
00575                         }
00576                         else
00577                         {
00578                                 queryParameter = this.SelectedQueryParameter;
00579                         }
00580                         queryParameter.VisibleName = this.TXTqueryParameterVisibleName.Text;
00581                         queryParameter.TypeText = this.DDLparameterType.SelectedValue;
00582                         if (queryParameter.Type == QueryParameter.QueryParameterType.LookupFromTable)
00583                                 queryParameter.Table = this.SelectedTable;
00584                         else
00585                                 queryParameter.Table = null;
00586 
00587                         if (queryParameter.Type == QueryParameter.QueryParameterType.LookupFromQuery)
00588                         {
00589                                 queryParameter.RelatedQuery = this.SelectedRelatedQuery;
00590                                 queryParameter.Table = this.SelectedTable;
00591                         }
00592                         else
00593                                 queryParameter.RelatedQuery = null;
00594 
00595                         return queryParameter;
00596                 }
00597 
00598                 private bool GetVisibleNameControlVisible()
00599                 {
00600                         bool enabled = false;
00601                         RAIS.Common.TableManagement.Query query = this.SelectedQuery;
00602                         QueryParameter.QueryParameterTypeData queryParameterTypeData = this.SelectedQueryParameterTypeData;
00603 
00604                         if ((query.Type == RAIS.Common.TableManagement.Query.QueryType.PreselectionList
00605                                                         || query.Type == RAIS.Common.TableManagement.Query.QueryType.Query
00606                                                         || query.Type == RAIS.Common.TableManagement.Query.QueryType.Statistics)
00607                                                 && (queryParameterTypeData.Type == QueryParameter.QueryParameterType.LookupFromTable
00608                                                         || queryParameterTypeData.Type == QueryParameter.QueryParameterType.LookupFromQuery
00609                                         )
00610                                         || (query.Type == RAIS.Common.TableManagement.Query.QueryType.ConsistencyCheck
00611                                                         || query.Type == RAIS.Common.TableManagement.Query.QueryType.EntryFilter
00612                             || query.Type == RAIS.Common.TableManagement.Query.QueryType.RanAutogeneration)
00613                                                 && queryParameterTypeData.Type != QueryParameter.QueryParameterType.PrimaryKey
00614                                                 && queryParameterTypeData.Type != QueryParameter.QueryParameterType.UserID
00615                                 )
00616                         {
00617                                 enabled = true;
00618                         }
00619 
00620                         return enabled;
00621                 }
00622 
00623                 private bool GetTableControlVisibility()
00624                 {
00625                         return (this.SelectedQueryParameterTypeData != null)
00626                                 && (this.SelectedQueryParameterTypeData.Type == QueryParameter.QueryParameterType.LookupFromTable
00627                                         || this.SelectedQueryParameterTypeData.Type == QueryParameter.QueryParameterType.LookupFromQuery);
00628                 }
00629 
00630                 private bool GetRelatedQueryControlVisibility()
00631                 {
00632                         return (this.SelectedQueryParameterTypeData != null)
00633                                 && (this.SelectedQueryParameterTypeData.Type == QueryParameter.QueryParameterType.LookupFromQuery);
00634                 }
00635 
00636                 private string GetVisibleNameLabelTranslatedText()
00637                 {
00638                         string translatedLabelText = string.Empty;
00639                         string labelText = string.Empty;
00640 
00641                         labelText = (this.SelectedQuery.Type == RAIS.Common.TableManagement.Query.QueryType.PreselectionList
00642                                 || this.SelectedQuery.Type == RAIS.Common.TableManagement.Query.QueryType.Query
00643                                 || this.SelectedQuery.Type == RAIS.Common.TableManagement.Query.QueryType.Statistics)
00644                                 ? "Visible name"
00645                                 : "Source field name";
00646 
00647                         translatedLabelText = RAIS.ApplicationLogicLayer.Localisation.Translate(labelText,
00648                                                                                                                                                                         this.ToString(),
00649                                                                                                                                                                         RAIS.Common.Constants.DEFAULT_LANGUAGE,
00650                                                                                                                                                                         this.CurrentUser.Language);
00651                         return translatedLabelText;
00652                 }
00653 
00654                 private string GetTableLabelTranslatedText()
00655                 {
00656                         string translatedLabelText = string.Empty;
00657                         string labelText = string.Empty;
00658 
00659                         labelText = (this.SelectedQueryParameterTypeData.Type == RAIS.Common.TableManagement.QueryParameter.QueryParameterType.LookupFromQuery)
00660                                 ? "Main table for query"
00661                                 : "Table";
00662 
00663                         translatedLabelText = RAIS.ApplicationLogicLayer.Localisation.Translate(labelText,
00664                                                                                                                                                                         this.ToString(),
00665                                                                                                                                                                         RAIS.Common.Constants.DEFAULT_LANGUAGE,
00666                                                                                                                                                                         this.CurrentUser.Language);
00667                         return translatedLabelText;
00668                 }
00675                 protected void ChangeOrder(bool isUp)
00676                 {
00677                         string returnMessage = string.Empty;
00678                         bool success = true;
00679 
00680                         int indexToCompare = (isUp) ? 0 : this.LBqueryParameters.Items.Count - 1;
00681                         if (this.LBqueryParameters.SelectedIndex != indexToCompare)
00682                         {
00683                                 int newIndex = this.LBqueryParameters.SelectedIndex + ((isUp) ? -1 : 1);
00684                                 this.SelectedQueryParameter.Order += ((isUp) ? -1 : 1);
00685                                 success = ApplicationLogicLayer.TableManagement.SaveQueryParameterOrder(this.SelectedQueryParameter, ref returnMessage);
00686                                 if (success)
00687                                 {
00688                                         //this.SelectedQuery = RAIS.ApplicationLogicLayer.TableManagement.GetTableByTableID(this.TableID);
00689                                         //this.LBqueryParameters.Items.Clear();
00690                                         //UI.Common.TableManagement.InitializeQueryParameterList(this.LBqueryParameters, this.CurrentTable);
00691                                         //this.LBqueryParameters.SelectedIndex = newIndex;
00692                                         this.InitializeQueryParameters(this.SelectedQueryParameter.Name);
00693                                         this.EnableUpDownButtons();
00694                                 }
00695                                 else
00696                                 {
00697                                         RAIS.UI.Common.MessageDisplay.DisplayReturnMessage(this.LBLresult,
00698                                                                                                                                                 returnMessage,
00699                                                                                                                                                 success);
00700                                 }
00701                         }
00702                 }
00706                 private void EnableUpDownButtons()
00707                 {
00708                         this.BTNup.Enabled = (!this.EditMode && this.LBqueryParameters.SelectedIndex > 0);
00709                         this.BTNdown.Enabled = (!this.EditMode && this.LBqueryParameters.SelectedIndex < this.LBqueryParameters.Items.Count - 1);
00710                 }
00711                 #endregion
00712         }
00713 }